declare @tabla nvarchar(200)
		,@qry nvarchar(200)
		,@cant int
declare @temp table (nombre varchar(200),cantidad int)
declare qtablas cursor for
	--select QUOTENAME(name)
		--from sys.tables
		select CONCAT(sys.schemas.name,'.',QUOTENAME(sys.tables.name))
		from sys.tables
		join sys.schemas  on sys.tables.schema_id = sys.schemas.schema_id
open qtablas
fetch next from qtablas INTO @tabla
while @@FETCH_STATUS=0
begin
	set @qry=N'select @cantidad = count(*) from ' + @tabla
	exec sp_executesql @qry, N'@cantidad int output', @cantidad = @cant output
	insert into @temp
		values (@tabla,@cant)
	fetch next from qtablas into @tabla
end
select*
from @temp